﻿/****************************************************************************************************
 ** Name:        tdSQLErrorLog
 ** Description: Prevents the deletion of the SQLErrorLog records.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

CREATE TRIGGER dbo.tdSQLErrorLog ON dbo.SQLErrorLog INSTEAD OF DELETE
AS 
  BEGIN
  	RAISERROR('Deletions are not allowed on the SQLErrorLog table.', 16, 1)
  END
GO
EXEC sp_addextendedproperty @name='MS_Description', @value ='Prevents the deletion of the SQLErrorLog records.', @level0type = 'SCHEMA', @level0name = 'dbo', @level1type = 'TABLE', @level1name = 'SQLErrorLog', @level2type = 'TRIGGER', @level2name = 'tdSQLErrorLog'
GO